﻿using System;
using System.Data;
using System.Text;
using System.Data.OracleClient;
namespace OracleDAL.Sec
{
	/// <summary>
	/// 数据访问类Dictionary。
	/// </summary>
	public class Dictionary
	{
		public Dictionary()
		{}
		#region  成员方法
		/// <summary>
		/// 得到一个对象实体
		/// </summary>
		public Model.Sec.Dictionary GetModel(string CODEISN)
		{
            string sql = "select * from SEC_DICTIONARY where CODEISN='" + CODEISN +"'";
			
			Model.Sec.Dictionary model=new Model.Sec.Dictionary();
            DataSet ds = DBUtility.OracleHelper.Query(sql);
			if(ds.Tables[0].Rows.Count>0)
			{
				model.CODEISN=ds.Tables[0].Rows[0]["CODEISN"].ToString();
				model.CODEID=ds.Tables[0].Rows[0]["CODEID"].ToString();
				model.CODENAME=ds.Tables[0].Rows[0]["CODENAME"].ToString();
				model.REMARK=ds.Tables[0].Rows[0]["REMARK"].ToString();
				return model;
			}
			else
			{
				return null;
			}
		}

		#endregion  成员方法
	}
}

